Table Viewer displays the table data as a grid. Data can be displayed in three modes: Grid View, Form View and Text/Blob View. See Data View for details.
The toolbars of Table Viewer provides the following functions for managing data:
- Commit
Make permanent all changes performed in the transaction. - Rollback
Undo work done in the current transaction. - Import Data
Import data from TXT, CSV, XML, DBF, MS Excel and ODBC.
- Export Data
Export data to TXT, CSV, DBF, XML and MS Excel.
- Filter Data
Allow you to filter records by creating and applying filter criteria for the data grid. - Edit TEXT/BLOB/BFile
Allow you to view and edit the content of TEXT, BLOB and BFile fields.
Note: Only Oracle supports BFile.
Hint: The Commit button is visible only when Auto Commit is disabled under Preferences.
Note: Available only for Oracle, SQLite and SQL Server.
Hint: The Rollback button is visible only when Auto Commit is disabled under Preferences.
Note: Available only for Oracle, SQLite and SQL Server.